Jump to content

Help with relationships and multiple value lists

Graham A

This topic is 8176 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a database containing various safety warnings to appear on product packaging. eg do not use near fire, wipe clean only, not suitable for children under 18 months etc. There are 125 different safety warnings in total each appearing in 6 different languages. Each product may require between 3 and 15 safety warnings in each of the 6 different languages.

I want to set up a database that collates the various safety warnings for each product and dumps them into 6 seperate fields one for each language which I can then copy and paste onto the packaging artwork.

Ideally I thought if I created a file containing a field for the product code and 15 pop-up value lists each containing all 125 product safety warning numbers I can scroll through the lists one at a time selecting the require warnings in order and have 6 fields at the bottom of the page for the selected warnings to flow into (one for each language) I can then copy and paste as mentioned earlier.

Even as I type this it sounds easy but I just can't get my head round how to achieve it in FM. Is anyone prepared to go through the steps in fairly laymans terms before I run out of hair to pull out!!!

Thanks Graham

[ February 22, 2002, 06:59 AM: Message edited by: Graham A ]

Link to comment
Share on other sites

First of all you should create a warnings library. Each warning is a record with a unique ID. Create a different field for each language you need.

WarningID (text)

English (text)

French (text)

German (text)

Spanish (text)

Itialian (text)

Russian (text)

Also create a calc field that = 1

In your other db create another constant field = 1 then create a relationship between the two constant fields.

This will then allow you to create a portal to view the entire warning db.

Create 1 field in this database (text) that will be the lookup for the warnings.

Since a product can have multiple warnings you would put the warning ID in this field seperated by returns:


Link to comment
Share on other sites

This topic is 8176 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.