Using values from current records fields only...

[Mariano]

Hi-

I have something I am using to Invoice Match to Purchase Orders. I have given the user the option of referencing multiple Invoice Numbers for each PO. This is a repeating field labeled "Invoice #", and next to each line item I have "Invoice Referenced" which should reference a value list of all the Invoice #'s entered for this particular order. So I made the value list set by the field "Invoice #". However when I do this it is pulling up all invoice numbers throughout every record in the database. Can I do something to make it only relative to the Invoice #'s entered for that particular record??

Also, can I default it to the first Invoice number entered?

Thanks!

[Mariano]

I have tried establishing a self join, and I created a new table... nothing is working...

very confused!