Something I was thinking about (just to make my interface easier)
I'd like to create a listbox with data from 2 tables (tblOne and tblTwo)
tblOne has fields HName (short text) and HThemeID (number, used to link to a master table in a relationship)
tblTwo has fields OName (short text) and OThemeID (number, used to link to a master table in a relationship)
I'd like to see HName and OName in a single column with HThemeID and OThemeID in a second column
I've looked around but can't see a way of doing it; is it possible?
EDIT
To explain further I'll provide data
INPUTS
tblOne
tblTwo
RESULT
Listbox
In essence the ID column is not being used for anything in the list box (it's not indexed or unique or autonumber or primary key), it's just another field with a value.
I'd like to create a listbox with data from 2 tables (tblOne and tblTwo)
tblOne has fields HName (short text) and HThemeID (number, used to link to a master table in a relationship)
tblTwo has fields OName (short text) and OThemeID (number, used to link to a master table in a relationship)
I'd like to see HName and OName in a single column with HThemeID and OThemeID in a second column
I've looked around but can't see a way of doing it; is it possible?
EDIT
To explain further I'll provide data
INPUTS
tblOne
HName | HThemeID |
Hobby1 | 1 |
Hobby2 | 2 |
tblTwo
OName | OThemeID |
Occ1 | 1 |
Occ2 | 2 |
RESULT
Listbox
Name | ThemeID |
Hobby1 | 1 |
Hobby2 | 2 |
Occ1 | 1 |
Occ2 | 2 |
In essence the ID column is not being used for anything in the list box (it's not indexed or unique or autonumber or primary key), it's just another field with a value.
Last edited: