dbTalk Databases Forums  

Linking a feature via many tables fm8.5

comp.databases.filemaker comp.databases.filemaker


Discuss Linking a feature via many tables fm8.5 in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Plume
 
Posts: n/a

Default 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!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.