Multiple records with one form

[CandyBoy]

Ok this is prob a very simple questions but, I have to be able to track several locations for each client in our database. From the client screen you can click Add Location and another form that carries over the CustomerID to link it to the customer, the problem is that i need to tie several locations in and if i use the new record function then it doesn;t attach the new location to the same customer. (FYI: the CustomerID is the primary key, autonumber, and is hidden in all the forms) Hope i explained this well, any help would be greatly appreciated

 

[shacket]

You need to have your locations in another table linked to the client. Then, show the locations with a subform (which will show all locations for the client displayed in the main form). If you add a location to the subform, it will link to the main form client.

 

[CandyBoy]

thx, worked great don't know why i didn't think of it