We have a central client database (client.db), and want to create another db for invoices (invoices.db). The problem I have is that I want to run a script in client.db (initiated by clicking a button) that will open the invoice database and create a new invoice for the current client (in client.db)

Therefore there will be many records (invoices) in the invoice.db against each client. Can anyone help?:?:??

Thanks

Yes.

You might want to elaborate a little more on the question. What part do you need help with?

-bd

dear tom, i do not understand your problem, so you are going to have one to many relation, so what?

as a mater of fact, is a good plan to have it that way.

now, if your problem is to refer to an existing invoice from the client file, you can use a portal, and use the relationship:

INVOICE::clientID

and if you are going to refer the client from the invoice, you just have to create a button that goes to related record.

May be there is something more complex that i did not get from your problem description, if so, let me know.

bye, and may the force be with you

------------------------------------------------

"There is always a way, but some times there is not a car to take it"