How did you set this up on your layout? Best guess if that The same invoice date field has been placed twice on your layout.
A typical invoicing system has at least these tables:
You create a new record in Invoices each time you log a new sales transaction. A portal to LineItems is use to list each item sold on that one invoice, with pricing and description information looked up from the ProductsServices table.
Here's a simple demo file you may want to examine and compare to your file: http://fmforums.com/forum/showpost.php?post/309136/
Or the date field is set as a global...
yes I copied the invoice date and number twice - so I m guessing u cant have the same field twice and have two different values? I was trying to reduce the number of tables
Usually you want more tables, not fewer as it is in the relationships between tables that you can harnass the power of a relational databse design.
You can have the same field twice with different values, but only if the fields are from different records instead of the same field in the same record.
A text field can hold, let's use numbers, a number of numbers. This field with multiple values can be linke to a number field in the child file and this link can pull up multiple records. Text can also be used. Didn't try dates.
If the text field contains:
And the child file has a number field with those values if four different records, they will show up in portal, etc.
I've used a text field formatted as a checkbox with the value list of all of the states and used that to 'filter' a portal, etc.
(Don't tell anyone but a repeating field can also be used...)
I agree Jack, but it's not what our OP should use in this situation...