Hi there,
I have 2 tables in Access, the primary table is called tbl_Clients, with a form frm_Clients, which is used by the user to create a new client record,
tbl_Clients has a primary key ClientID.
The second table is called tbl_Reports with a form, frm_Reports, this table uses ClientID as its foreign key.
When the user creates a new record by entering data into frm_Clients a new primary key (ClientID) is created, the user then needs to make use of this key in the frm_Reports. I s there a way to do this automatically, I know Access doesnt do this automatically.
As a workaround to try and to this I created a query that when run displays the last entry in the ClientID column in the primary table(tbl_Clients) when the user enters a new record . The trouble is I need to run the query every time to display the result, is there some way of doing this without having to run the query every time? Ive tried looking at the some SQL threads but couldnt get them to work
Thanks a lot for any guidance
I have 2 tables in Access, the primary table is called tbl_Clients, with a form frm_Clients, which is used by the user to create a new client record,
tbl_Clients has a primary key ClientID.
The second table is called tbl_Reports with a form, frm_Reports, this table uses ClientID as its foreign key.
When the user creates a new record by entering data into frm_Clients a new primary key (ClientID) is created, the user then needs to make use of this key in the frm_Reports. I s there a way to do this automatically, I know Access doesnt do this automatically.
As a workaround to try and to this I created a query that when run displays the last entry in the ClientID column in the primary table(tbl_Clients) when the user enters a new record . The trouble is I need to run the query every time to display the result, is there some way of doing this without having to run the query every time? Ive tried looking at the some SQL threads but couldnt get them to work
Thanks a lot for any guidance