Assigning #'s based on two criteria

[flea]

Hi,

So I'm trying to write a program that can search through part shipments by every nth shipment. To do this I was thinking I wanted the program to assign an ID number based on the date the part was received and the vendor number, that way each part coming in on a shipment could have the same ID number.

for example

ID #	Date Received	Vendor #	Part #
1	11-27-19	36300	AGXXX
1	11-27-19	36300	EXXXX
1	11-27-19	59800	LXXXX
2	11-30-19	36300	FXXXX
1	11-30-19	32400	KXXXX

Is there a way to do this?

I already have a table that collects Vendor #, Date, Part #, Material, etc. from a form.

Thanks!

[ranman256]

youd have a master & child table/form

master form would have ID field
the child table and form would also have ID field.
the child subform would be bound to the parent form via ID field (link master fields, link child field)

enter 1 in the master form id field
now every item you enter into the subform will assign 1 in ID to every record.