Hi,
I'm a newbie with access, and I have a problem understanding table relationships.
My application is a single session where I want user to input some data in forms. The data are basically checklists for a single job, but I want to logically separate them in forms or tabs. All data should be related to the Job ID that he enters in the first form.
I tried to separate the tables based on the tabs with the primary key in the first table as "Job ID", but I don't want the user to enter the "Job ID" in every form, just once and it should update the foreign key in the other forms. But this doesn't happen.
Is what I'm asking possible? or am I doing something wrong?
Thanks for your time & help.
Regards,
Ali