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?
When I created the form, the control for that table field had the up/down lookup arrows on the control, even though there was no list to look up.
Could not delete it. I started over with a new database and got the same results.
Now - every single form I try to create, either in existing databases or new ones, has the lookup arrows on every control of a text field. I am not adding lookups to the tables or the forms.The forms have no lists of data to look up, just the arrows.
How do I get rid of this? I have done several dozen tests and keep getting the same results.