Jump to content

Alex T.

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Alex T.

  • Rank
  1. Alex T.

    Is this a join file question?

    I'll expand :-) Each product in the database may (or may not) have various options applied to it. For example, a piece of jewellery may have options which affect the price, such as metal type, stone type etc. Some different products will have options which don't affect the price, such as colour. I have been trying to implement this with conditional value lists, but I fear it is over my head at this stage :-(
  2. Alex T.

    Is this a join file question?

    Thank you everyone for your help :-) The idea was to keep all the different supplier's products seperate so that each file could have a different range of options available, specific to that range of products. I agree that a single products database is the way to go, but what about the options? I'm new to all this, but I'm figuring it out slowly. Thanks again everyone for all your advice!
  3. Alex T.

    Is this a join file question?

    Hi LaRetta, Thanks for your advice in this matter. I agree that it would be simpler to use one single product database, but I was really hoping to use one per supplier. Is this possible in this case, or should I just resign myself to using one? TIA
  4. Hi, I'm relatively new to filemaker, and any help in this matter would be greatly appreciated. My databases are: Sales (Imported from a text file, basically a glorified invoice) Orders (this is orders to suppliers, the product codes are read from the sales database) Products (There are more than one of these databases, one per supplier) I am trying to work out how to make the Sales database read in descriptions and pricing information from different product databases depending on the supplier. Each product has a 3 letter code identifying the supplier, and all codes are unique, but I can't define a relationship from this field to more than one database. I have read on the forums about using a join file to accomplish this, but I can't make it work for the life of me :-( Can anyone help me?

Important Information

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