ms access tables (1 Viewer)

Hi All. Can anybody help me? I have a database with 2 tables: 1 for the clients personal details and one for each time they use my service. The first one is called Client data and the second one is called event data. How can i input the client name in the event data and automatically shows also in the client data table?

As you've stated it, you can't. But it can be accomplished via forms.

Create 2 forms--one based on the clients data and one based on the service data. Then, you make the service form a subform on the client form. That way you can open a client, type info into the subform and it knows what client to add. Check out this link for details:

https://support.office.com/en-us/ar...any-form-ddf3822f-8aba-49cb-831a-1e74d6f5f06b