Customer Table and Company Table Relationship

[mycanario]

Hi.

I am a newbie, so please go easy if I asked any silly question. I have a question: I am creating 2 tables:

customer table ( customer_id, firstname, lastname, mobile, email, and notes) and company table (company_id, companyname, website, address, province, zip and country).

I am creating a single layout to include a entry form with a section for customer and section for company. I am having problems, when I am trying to assign an existing company name to a new customer ..Or, creating a new company for a new customer. I can not get to set the company id to right case for each of them. if existing company, no need the auto -entry company_id , if no existing, then keep auto-incremental with an unique number to company_id.

I hope, I was clear enough...Thank you very much for everything.

[efen]

You will need a third table - a join table - to connect your customer and company tables. (I would assume that your companies will have more than one customer, and customers may use more than one company - that is why you will need a third table to make this possible/easier.)

Look at the following post/file attachment by comment for some guidance:

http://www.fmforums.com/forum/showpost.php?post/246136/

If you need further help please post again.

Welcome to the forums

[mycanario]

Thanks a lot.

It helps me.