Can anyone please help.

I am creating a client database and have created three files

1)organisation - hold company info including Address etc.

2)contacts - holds specific peoples contacts with organisations requiring many to one relationship

3)Main - where I am trying to put all my layouts.

My problem is that i want to put a layout for creating a new contact in the main file but it is creating a new record in organisation as well. How can I get around this.

You may want to add another database specifically for contacts only. Then establish a relationship between you "company" database and the "contacts" database. Then using a portal box you can view the related "contacts" within any given "company" database and have the ability top add "contacts" without creating new "companies" at the same time.

[ October 17, 2001: Message edited by: trevgriff ]