easy subform question

[jason.kohout]

I'm new at this.

I have objects. These objects are directly related to one another. I
have a separate table for the relationship-- Id1 and Id2. i have a
form for each individual object. How do I make a subform that will
show Id1 and Id2 when it is relevant--Id1=the current object's ID or
Id2==the current object's ID. I'd like to be able to input to this
form/subform and perhaps even use the names from the individual's
tables in order to select them in a combo box.

Thanks,

Jason Kohout
(e-mail address removed)

 

[Steve Schapel]

Jason,

Can you please give some more details of what you are doing? Some
specific examples would really help. What do you mean by "objects"?
What is the nature of the relationship between the tables (most commonly
this is a one-to-many relationship, i.e. there can be more than one
record in the second table associated with each record in the first). I
suspect it will be important to look at your data design before any
consideration of forms and subforms.