But as a rule I like to keep my Key ID as the first field in all of my tables, so never use this method.Īlso I've related the tables with Left or Right Join rather than Inner Join. field1=displayed text or value, field2=ID key, in that order. If your tables are laid out just so, you can use the table directly for your pull down, i.e. Sometimes SQL is better and sometimes Query is better, depending on what you're doing. ![]() I purposely made the Hosts lookup use a query and the ports lookup use SLQ so you could see the two most common ways of getting the pull down list. In Access either combo or list boxes will work.) (Note that combo boxes can't be used for this in LO because they only operate on a single field and you need two fields, an ID and something that is the human readable reference to that ID. ![]() You can poke around to see how the rest of it is built I think.Īfter you insert the table control, you need to right click on the fields to change Host ID and Port ID from a numeric field to a List box field. Download this example which I hope is what you want. I think an example is worth a thousand words.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |