Seperate date/items

[Ms.E]

I think this is where I need to post - new to fmp.

I am building a database where I need to have a list of dates (our trade shows) -- got that as radio buttons. I also have a field that lists all of the items we sell -- they never change and the price never changes. Now I need to know how to set it up so that when I click one of the radio buttons in my date list and then click buttons from my items list that it will associate those items to that date. Then if later in the year that same contact comes to another show and buys the same (or different items) it will track what items were purchased on each date. Can I do this using just the 2 fileds, but somehow set it up that it keeps track seperately (so I can created reports about what an individual purchased at each date throughout the year?

Hope I decribed that well!!

Im on a mac and I am using fmp6

[Kent Searight]

Hi, and welcome to the forums. It sounds like you need 3 separate files; 1 for your items, 1 for your event dates, and 1 for purchases. Your file for purchases will serve to join the other two files, i.e. it will relate to the event via an event ID and it'll relate to the item via an item ID.

Make sense? You could then set up portals in both the event and the item files to see at a glance which items were bought at a given event and at which events an item has been sold at.

Hope this helps!