Can not bring up correct address in report

  • Thread starter Thread starter Bandit
  • Start date Start date
B

Bandit

I asked this before, but got no response so I will try to reword the
question. I have the form working fine. I have created a report based on
the form information. the report brings up all my purchase order
information from my main form fine. The report brings up all the items
purchased from my sub-form fine. The report brings up the supplier info
fine from the main form fine. Now, I want the address for the supplier to
auto populate the form right under the supplier name. I copied the design
view of a template off MSOffice to make this report. Everytime I run the
report everything works except one thing. When the Supplier address
populates the field it is always the address of the first supplier in my
supplier table. I can change the supplier as many times as I want but the
address "Always" comes up as the first supplier address in my table. What am
I doing wrong?

Here is a sample of the table structure.

POTable

SupplierID-to SupplierID (Many to one)
POID-PO Detail ID(Subform) (one to many)


I assume this is a relationship problem and I just don't get them.
Thanks for your help

Bandit
 
As I understand there is a Supplier table, which includes the address; a PO
table, in a one-to-many relationship from the Supplier table; and a PO_Items
table, in a one-to-many relationship from the PO table.

tblSupplier
SupplierID (primary key, or PK)
SupplierName
etc.

tblPO
PO_ID (PK)
SupplierID (foreign key, or FK, to tblSupplier.SupplierID)
PO_Date
etc.

tblPO_Item
Item_ID (PK)
PO_ID (FK to tblPO.PO_ID)
Description
etc.

You say the form is "fine", and that the report brings up all the PO
information "fine", but then you say it does not bring up the correct
Supplier address. Are you storing the SupplierName in each PO record, or
are you storing the SupplierID? It should be the latter. How are you
trying to get the address into the report? What is the report? Is it the
PO itself, or is it summary information of several POs, or what exactly?
What is its record source.
You have provided some information about how things look, but without
information about the undrlying structure it will be difficult to provide a
meaningful response.
 
Back
Top