When you say "I use two other databases.." I asssume you are talking about two other tables in the same database?
First you need to make a relationship. That needs to be based on a Unique ID number.
So you would have your table "Clients" with fields like:
ClientId (this is your serial number value) it's called your Primary Key (PK)
Then you would have your table "Services"
That would have the fields:
ServiceId (Unique number) PK
ClientIdFK - this one is a number field and it contains the PK of the client. This is called a Foreign Key (FK)
Now you make a relationship between those two fields:
Clients::ClientID ----< Services::ClientIdFk
If you make a layout based on the "Service" table you can now just place fields from the "Clients" table in your layout and fill them out.
I hope that helps.
Thanks for the reply!
I'm checking it tonight to see if it works!
What about the "Products" table, because I will be probably using different products in one Service record.
How do I manage that?
It sounds to me that what you need is a pretty standard "Invoicing" type of structure.
Where you have a table Services, a table Clients, a table Products.
And you create a table "LineItems" to put multiple products on one service.
Have a look at the example file in this thread:
And see if that structure is something you might be able to use for your solution.