Jump to content

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

Recommended Posts

  • Newbies

Please help.

I am developing a database to manage logistics for a concert production company.

I have a table for individual inventory items, and I have a table that groups items together. For example:

10 Individual pieces of sound equipment gets grouped into a rack of gear called AFXRACK. Once the group of items is built, the idea is to put AFXRACK on to my reservation table so that 10 pieces of gear can be reserved using only one model number. The problem I have encountered is when I add an individual item onto a reservation, lookups are performed (description, price, etc). But a lookup can only refer to one table, so when I add a group item, the lookups are still looking to the Individual item table, not the groups table. I would like to keep these tables seperate because data entry gets muddy trying to put groups and individual items into the same database. My thought is if I could somehow create a table that would join data from the Indidvidual item table and the group items table, then my lookup problem would be solved while maintiaing two seperate tables. But I can't figure out how to do that.

------------------

Roy

Link to comment
Share on other sites

You are making things too complicated. Your "Component" file (i.e. speaker, microphone, etc) is used to provide information to your "Item" (i.e. AFXRack, etc) file, which then provides information to your "Reservation" file.

The Reservation file only need to look into the Item file to get all of the pertinant data. You do not need to look into the Component file, let the Item file do that for you.

Setup all of you stuff in the Item file, if the Item has a bunch of different parts, then set those up in the Components file.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

I'm not sure I'm following you exactly, but if you write a script such that it finds in the group field first, it uses the data which is there. If there is no data there ( "" ), else search the items field and use that data, and if no data there, quit the script or perform new task.

Link to comment
Share on other sites

This topic is 8819 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.