D
Don
Hi,
I have a form for property data with a table record source that
contains all the pertinent data to the property i.e. size and physical
characteristics. Within that form I have a subform that looks like a
list to record bids received for that property. The subform's record
source has a one-to-one relationship with the main form's record source
so that the bids received are unique to the property in the main form.
My subform's table has unique records which include the same
SaleUnitID. Each record has a field for Bid1Date, Bid1Name, Bid1Amount,
Bid2Date, Bid2Name, Bid2Amount and so on up to ten. I thought this
would okay but now I'm having trouble querying the data by bidder's
name. In some records they are Bid1Name and in others they are
Bid2Name. Also, the amounts are not directly linked to any specific
bidder.
I figured that I better replace that table with one that has a unique
record for each bid and its data. I figure that I can create a
one-to-many relationship with the main table by still using the
SaleUnitID.
However, I'm unable to figure out how to replace the subform. I would
like it to look like a list of bids for the user but I don't know how
to allow multiple record entries from one form display.
I have a form for property data with a table record source that
contains all the pertinent data to the property i.e. size and physical
characteristics. Within that form I have a subform that looks like a
list to record bids received for that property. The subform's record
source has a one-to-one relationship with the main form's record source
so that the bids received are unique to the property in the main form.
My subform's table has unique records which include the same
SaleUnitID. Each record has a field for Bid1Date, Bid1Name, Bid1Amount,
Bid2Date, Bid2Name, Bid2Amount and so on up to ten. I thought this
would okay but now I'm having trouble querying the data by bidder's
name. In some records they are Bid1Name and in others they are
Bid2Name. Also, the amounts are not directly linked to any specific
bidder.
I figured that I better replace that table with one that has a unique
record for each bid and its data. I figure that I can create a
one-to-many relationship with the main table by still using the
SaleUnitID.
However, I'm unable to figure out how to replace the subform. I would
like it to look like a list of bids for the user but I don't know how
to allow multiple record entries from one form display.