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!