I have a form with a combo box to select which building a customer is in. Here's the data:
Customer
Building
Buildings
ID
streetNameNumber
address
champion
dayofweek
At the moment I have it set-up so that the combo box shows the streetNameNumber and address columns when you drop it down, and it saves the ID to the Building field in the related table. I would like to:
I've looked at a book on Access but it's not much help, and browsing around hasn't made me any wiser either. I'm doing this all through the UI and haven't done any Access programming before, but I'm familiar with Perl/Python/etc. so I'm quite happy to get my hands dirty if someone is willing to guide me through it...
Customer
Building
Buildings
ID
streetNameNumber
address
champion
dayofweek
At the moment I have it set-up so that the combo box shows the streetNameNumber and address columns when you drop it down, and it saves the ID to the Building field in the related table. I would like to:
- Have both the streetNameNumber and address field values show when the combo box is inactive (currently it only shows the address field)
- Either put the champion and dayofweek fields into the combo box, or (as that would get pretty huge) have the champion and dayofweek fields into text fields below that show the appropriate data and update when the combo box changes
I've looked at a book on Access but it's not much help, and browsing around hasn't made me any wiser either. I'm doing this all through the UI and haven't done any Access programming before, but I'm familiar with Perl/Python/etc. so I'm quite happy to get my hands dirty if someone is willing to guide me through it...