Insert date in 2 tables

[justdippin]

Hello everyone,

sorry for my noobisch question but I just started to develop with filemaker pro 8, 2 days ago and im getting a headache:(

I have a DB model with 2 tables:

Company

Contacts

This is a 1:N relationship, since the are more contacts within one company.

Table Custumer contains

Custumer_id (primairy key)

Name

Company name (sec key)

Table customer

Company Name (pri key)

I have linked the 2 tables in the define DB options.

How do i record a new entry of company name, in the company AND the customer table, by only fillin out one field?

thx everyone for reading and even more if you're repying

JustDippin'

(any tips would be most welcome as well :

Edited January 31, 2006 by Guest

[RalphL]

First In the table Company add a field Company_ID use this as the primary key.

In the table Customer replace the field Company_Name with Company_ID.

In your layout for Customer add a field Relation to Company::Company_Name.

You have a one to many relationship, I wonder if you don't need a many to many relationship. A customer could be a customer of more than one company.