How to connect table

[manish2952]

I have two tables


1. client table
2. billing table

My entire data related to clients are saved in 1st table (e.g. client ID address, contact no., name etc)
And my bill related data are saved in 2nd table (eg. client ID, Discription of service, amount etc)

My query is that only by inserting client ID in 2nd table, the other fields related to client data (e.g. address contact no, etc) filled automatically

[June7]

Should not save related client info in billing table, only the clientID.

Build queries to display all related data.

Use the query designer. Access Help has guidelines.