Linking a feature via many tables fm8.5 -
11-24-2006
, 04:57 AM
Filemaker pro 8.5
Hello everyone
I am developing a DB of suppliers, and here is my problem:
I've created a table "suppliers" with all the general info such
as "Name", "address", ecc. Plus a primary key "ID
supplier", an auto enter serial number.
But each supplier belong to a specific type, such as "hotels",
"restaurants", and each of this types have different features (for
eg. "hotels" have a "N°of rooms", or the restaurants have a
"n° of seats"), so I've created a table for each type of
supplier with just the primary key form the main table suppliers ("ID
supplier") and many fields for the specific info of each supplier
(eg. For hotels "N°of rooms", "distance from the airport",
ecc.).
But how do I put all this together? How do I tell to FM that if the
supplier is an Hotel it should relate it to the "hotel" info table?
Thanks for any suggestion! |