Hi,
I have linked an Oracle Table into my Database.
I have created a form which takes 6 fields from this table:
EV200_EVT_DESC - Event Description
EV200_EVT_ID - Event ID
EV200_START_DATE - Start Date
EV200_END_DATE - End Date
EV200_MI_DATE - Move in Date
EV200_MO_DATE - Move Out date
Obvioulsy when this is done and open, I have a form with the same amount of records as there are in the Oracle Table.
I want to be able to have the form as one single record, but with a pull-down list of the events, so that when the user selects one of the events - all of the other details are filled in.
How can this be done. Can you tell me if I need to create queries/subforms or a blank replica table in Access etc?
If you give me the overall picture, I can try this and then ask any detailed questions after - if needed.
I appreciate your help,
Matthew
I have linked an Oracle Table into my Database.
I have created a form which takes 6 fields from this table:
EV200_EVT_DESC - Event Description
EV200_EVT_ID - Event ID
EV200_START_DATE - Start Date
EV200_END_DATE - End Date
EV200_MI_DATE - Move in Date
EV200_MO_DATE - Move Out date
Obvioulsy when this is done and open, I have a form with the same amount of records as there are in the Oracle Table.
I want to be able to have the form as one single record, but with a pull-down list of the events, so that when the user selects one of the events - all of the other details are filled in.
How can this be done. Can you tell me if I need to create queries/subforms or a blank replica table in Access etc?
If you give me the overall picture, I can try this and then ask any detailed questions after - if needed.
I appreciate your help,
Matthew