A list of links to basic and advanced FMP info - the first five are a good start with database design
There are two piles of index cards on the floor.
1 Pile has the info in your first table, the other pile has the info in your second table.
Picking up a card from the 2nd pile will only give you info on that card.
Creating a relationship between the cards by tying yarn to related cards will allow you to
Pick up a card from the 2nd pile and all the cards tied to it in the firs pile.
I have a complete grasp of relational data. What I need is a search/select on unrelated data. The retail data is a table of about 2000 locations (name/city/state). I can't use a dropdown list for this because I can't do any sort of real searching on that. I can't seem to use a portal because this appears to be only for related records.
I need to search for a record in the retail list, grab the ID for the selected record and store that ID in the appropriate field on my survey table.
I'm not sure your grasp is as complete as you think.This sounds like data that SHOULD be linked in a relationship even if it might use the X operator so that your portal lists all retailers in the table in a portal.
Yes. That's pretty much exactly what I was doing. The odd thing is that I had an existing layout that I was using to display the lookups. I had set this up before assigning the table relationship. After I set the relationship and tried to look at the data in this lookup layout, it was always blank, even though there were 2000+ rows.
I deleted the layout and recreated it, and everything worked fine. Seems like an oddity to me. Thanks for the reply.