Don't Repeat Record?

From: ThePro (ThePro_at_discussions.microsoft.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 05:37:02 -0800

I have a querie with 2 linked tables. One contains all of the invoices for
the customers [customers ID only] with the location they made the purchase
[multiple locations] and a table with the customers info [address, phone,
etc]. I was able to link them with no problem. The problem is that I don't
want the queire to repeat records. Obviously the invoice table needs to
repeat IDs since each customer has multiple invoices, but I don't want this
querie to repeat them since what I need is a list of customers which made a
purchase at one of our specific locations and their respective addressess.
Right now the querie is returning alot of info [alot of rows] since it's
repeating records.

Is this possible?

Thanks

Relevant Pages

  • Re: FIND across multiple tables in FM 7.03
    ... Surgery fields over to the Exam layout as related fields? ... > customers to invoices on id, and then put the related invoice total ...
    (comp.databases.filemaker)
  • Re: FIND across multiple tables in FM 7.03
    ... > fields must be placed on the 'parent' layout. ... > customers to invoices on id, and then put the related invoice total ... (You can use a portal to display multiple related records). ...
    (comp.databases.filemaker)
  • Re: Calculated Value will not store in Table
    ... >So, if we have Customers, and Invoices tables, a left ... So, our main table Customers ... >tblBgroup (booking group) for example may, ... >The tables that MUST have a child records can also ...
    (microsoft.public.access.forms)
  • Re: Word merge pulls from wrong table column
    ... If you need that text from the other table, then base your form on a query, ... So, if we have Customers, and Invoices tables, a left join would give us: ... Only include rows where the joined fields from both tables are equal ...
    (microsoft.public.access.forms)
  • Re: Word merge pulls from wrong table column
    ... If you need that text from the other table, then base your form on a query, ... So, if we have Customers, and Invoices tables, a left join would give us: ... Only include rows where the joined fields from both tables are equal ...
    (microsoft.public.access.forms)