need help; relational database subject

[peter2424]

unfortunately, i have fp 6.0 and this is the closest topic to my question:

i want to create (i think) relational databases that are associated with each other with this situation:

i want to enter a code (call it 'code 1') in a field. when i do that, a second code will be associated with it (call it 'code 2'). another field is a description of code 2. i also want it to work visa versa (look up description, and code 2 comes up).

i have 300 code 1's that is associated with 100 code 2's. each code 2 has a description.

i guess it's the same thing as someone looking up your telephone number (you also have 2 other numbers), and your address and zip code pop up. i want it work so you can also look up your zip code and all your telephone numbers show up.

thanks, peter at [email protected]