Looking up information

[Torilyn73]

Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I
need to be able to have multiple combo boxes, one from each table.. and
have them all share one field for displaying the chosen record.

Can anyone tell me if this can be done or not? If it can... how?

Thanks
Victoria

[Tom van Stiphout]

On 12 Jan 2007 18:30:49 -0800, "Torilyn73" <to*******@gmail.com>
wrote:

Only if you explain better. Remember, we have never seen your db
design, and don't even know the topic of your app.

If you want one form to display data from several tables, that can be
done by changing the RecordSource. Or by having a subform and changing
the SourceObject of the subform control.

"I can only have one field that shows the record selected": that
confuses me. What do you mean? Typically a record has several fields.

-Tom.

>Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I
need to be able to have multiple combo boxes, one from each table.. and
have them all share one field for displaying the chosen record.

Can anyone tell me if this can be done or not? If it can... how?

Thanks
Victoria

[Torilyn73]

Sorry.. I didn't explain very clearly. I have solved my problem
though.. thanks!

Tom van Stiphout wrote:

On 12 Jan 2007 18:30:49 -0800, "Torilyn73" <to*******@gmail.com>
wrote:

Only if you explain better. Remember, we have never seen your db
design, and don't even know the topic of your app.

If you want one form to display data from several tables, that can be
done by changing the RecordSource. Or by having a subform and changing
the SourceObject of the subform control.

"I can only have one field that shows the record selected": that
confuses me. What do you mean? Typically a record has several fields.

-Tom.

Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I
need to be able to have multiple combo boxes, one from each table.. and
have them all share one field for displaying the chosen record.

Can anyone tell me if this can be done or not? If it can... how?

Thanks
Victoria