First, I want to say that Xataface is perhaps the single greatest tool I could imagine using for the data collection and sorting that I am doing, and I want to express my sincere thanks for such a powerful and easy-to-use piece of software.
Ok, so, my dilemna right now:
I have two tables, a Vendor table, and an Image table.
In the Vendor table, I have AccountID, LocationID, and LocationName. In the Image table I have ImageID, AccountID, and LocationID. Each account will have many locations, but locations are unique. Each ImageID can be linked to multiple LocationIDs (also, right now the AccountID for the image field is already filled out properly).
My goal is, for the Image table, to have a valuelist that populates with the possible LocationNames based on the already filled in AccountIDs, and enters the LocationID(s) into the database. The main thing is that the valuelist needs to be dynamic, because people are constantly adding new location names.
Could someone give me a start? Anything you can offer would be a great help. Thanks!