question about creating lookup forms
I have a few fields that I want to assign lookup values to.
School (MLK High, Central High, Northeast High.)
Interests (Visual Arts, Drama, Sports, Literature.)
Color (Red, Blue, Green.)
I could create a table School, another table Interests, another table Color, and then have the source for each one to be SELECT Color.ColorName FROM Color and then SELECT School.SchoolName FROM School and then SELECT Interests.InterestPicker from Interest. this is how I usually do things.
But then I wondered if instead of three separate tables, I could have one table called ParticipantData with fields called School, Interests, Color. and then have my lookup queries be SELECT ParticipantData.School from ParticipantData, and SELECT ParticipantData.Interests FROM Participant, and SELECT ParticipantData.Color FROM ParticipantData
Are there advantages/disadvantages to one way or the other
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Creating a database; Creating tables; Changing the Field Properties in the tables; Adding Lookup Tables; Creating relationships; Adding Passwords to the database; Creating simple forms using the Form Wizard; Adding graphics and creating customized forms; Creating forms using multiple tables; Creating reports using the report wizard; Formatting reports; Creating Switchboards.
Is this doable or should I make 15 separate forms?
Except, when the down arrow is selected for the lookup, you can't see the names. The dropdown acts as if there is text there, the Admin table has 2 names and its dropdown has blank spaces for 2 names. The inspector table has 3 names and its dropdown has blank space for 3 names.
When you position the cursor where the name text should be in the drop-down and left-click, the name magically appears in the text box. I used the lookup wizard to create the fields and I can't figure out why I can't see the text, but it acts like its there.
After first I created a table that had a lookup value from the query but I got an error message that it would not allow me to do this
Is it possible to break the relationships created by the wizard and then recreate the relationships and have the lookup be done by the form withouthaving to completely rebuild the DB?
I have found many resources online with examples of different databases and in one I am going through right now, there is one that has a People table (for both people and companies) and a Type table.
The Type table categorizes the type of relationship between the person/company in the People table and (presumably) the user/company keeping the database (relationships such as: Friend, Family, Professional, Auto, Hospital, Art Supply, etc).
**In the description for the Types table, there is a statement that says "The Types table is commonly referred to as a lookup table."**
My question is this: Is a Lookup Field the same thing as a lookup table, as described?
I want it to display all three under the one column so to speak. The Lookup lists Order, Forenames and Surname but only lists the Order when selected.
Is there any way I can get three values under the one column rather than having to put three boxes with three lookup's and then the user having todo it three times to get the information?
Basically, I'm looking to create a table that holds event information. One of the fields I've successfully included is a Lookup function to pull info from a contacts table. This table also has statistics in it.
What I'd like to do on the events table is lookup a contact name in one field, and then in another field within the events table, pull over the relevant statistics based on my selection.
Now, I've been able to get the lookup to pull across all of this already, but as far as I can tell, you're only able have one column displayed (bound) in the lookup - is this right?
If you've any suggestions I'd love to hear them. Please ask if you need any more info