relationship issues

[H]

Hi

 

i created a database for a food manufacturing company, they need to be able to link the product with the company that ordered it with its ingredients and be able to link on e to another.

i created it that from the product you can select a value list of the company that ordered it ,  i created a relationship.

however every time i create a new product and assign it to a company a new company is created. i assigned automated id`s so i cant even link them together.

please help me

[Wim Decorte]

Not enough information... can you post some more details, screenshots, how the value list and the relationships are set up?

[H]

24 minutes ago, H said:

 

24 minutes ago, H said:

 

 

1 minute ago, H said:

 

Are you getting my responses?

 

13 minutes ago, Wim Decorte said:

Not enough information... can you post some more details, screenshots, how the value list and the relationships are set up?

first time working in this forum, wondering whether you are seeing my screenshots

 

[AnthonyDixon]

Can you upload your file?

[H]

Just now, AnthonyDixon said:

Can you upload your file?

 

Rabbi_Usher_Eckstien.fmp12

you see my issue, i have the same ssue when i go into the ingredient tab on the product page, it creates a new ingredient even if i select one from the databasde

[Steve Martino]

Says the file is damaged.  You should zip it first then attach

[Steve Martino]

When you create a new record, you should script the process--entering of the customer name, id#, etc., and turn off the 'allow creation of records through via this relationship.  The way you are set up, on the products layout you can change the Customer name without any notice, destroying your data.

[H]

hi, i am quite new to filemaker, can you guide me on how to script this

[H]

Hi, please, i am still awaiting help on how to script up the process from linking my product back to my customer without creating a new customer when i select it from the value list, please can someone help me.

[GisMo]

1 hour ago, H said:

Hi, please, i am still awaiting help on how to script up the process from linking my product back to my customer without creating a new customer when i select it from the value list, please can someone help me.

Here are things that you need and some HINTS.

Tables and Keys

• Customer Table
  • Primary Key: CustomerID (Auto-enter get(uuid))
• Product Table
  • Primary Key: ProductID (Auto-Enter get(uuid))
• OrderLineItem
  • Primary Key: OrderLineItemID(Auto-Enter get(uuid))
  • Foreign Key: ProductID
  • Foreign Key: CustomerID

You need at least the above to accomplish what you need.

Please See Attached, Reworked File. I've put the example in the Order Line Item Tab on the Customer Form. Also a simple script to show creation of the related record.

Rabbi_Usher_Eckstien_Recovered.zip

Edited November 11, 2015 by GisMo

[Lee Smith]

Please do no Double post

 I’ve deleted your duplicate post.

[H]

Thanks, will review and let you know if this matter has been resolved

[H]

Hi, just review the file you have reworked, however there is still the same issue, i see you made it that one can select a company in the product page however the company still duplicates, please let me know how i can fix this error as it is breaking my entie database

[GisMo]

@H please tell me how to duplicate your issue in the reworked file. Tell me what layout and what task. 

Edited November 11, 2015 by GisMo

[H]

on the product layout, when i create a new product and i select a company from the value list another company is created with the same name but different ID

[GisMo]

Are you purchasing products from the company?

[H]

oh i`m sorry you must of misunderstood, i wrote a mistake the customer is the one you manufactures the product

[GisMo]

@H, please meet me in the forum Chat now. 

[H]

it is a manufacturing database, i want to link the customer(the one creating the new food product) with the factory it is creating it in, with the ingredients the product is made up of

one customer, or rather company can manufacture many companies

sorry i am new to this, where is the forum chat?