I had made two tables linked with each other with the help of primary and foreign key.
When I combine the fields of both tables to make a form and try to enter values then the system doesnot allow me to enter value in that field who acts as the joining field in two tables.
The system errors that it does not find any matching value in the other table.
I had tried by choosing both primary key Field as well as foreign key field.
Actually my table is of Client Info and second table is of flight Info.
NIC# is the primary key in the Client Info table and it is acting as foreign key in Flight Info Table.
When while making the form If I choose the NIC# from parent table in which it is acting as primary key the system does not allow me to enter values in the fields of child table and prompts an error that"Cannot add record(s);join key of table not in record set" .
When I choose NIC# number form the table in which NIC# is acting as foreign key the system errors that "The current field must match the join key."