spectrolab
Registered User.
- Local time
- Today, 17:29
- Joined
- Feb 9, 2005
- Messages
- 116
Hi All,
I have a bit of a general query and I am hoping someone may be able to help out.
I have a table and currently it has 5 fields, one of which is a nine digit number, unique for each record, which is used as a barcode identifier. The Barcode field, ID, links this to a few other tables, so far, so easy.
Where I am kind of stuck is this:
I need a form to link to this table so that when I scan the barcode, it opens the record relating to this field and allows me to add the other data required for this record. I hope that makes sense.
Once I have done a few of these, the data in the table (only the records I have scanned, not the entire table) will be exported to a CSV file and used in another machine. This other machine will generate a new CSV file with the original data plus a new field (FinalWeight) which I would need to import back into the database.
I am fairly stumped as to how I might go about this, I have tried using temporary tables, but I seem to be making a mistake somewhere.
Any help would be greatly appreciated.
I have a bit of a general query and I am hoping someone may be able to help out.
I have a table and currently it has 5 fields, one of which is a nine digit number, unique for each record, which is used as a barcode identifier. The Barcode field, ID, links this to a few other tables, so far, so easy.
Where I am kind of stuck is this:
I need a form to link to this table so that when I scan the barcode, it opens the record relating to this field and allows me to add the other data required for this record. I hope that makes sense.
Once I have done a few of these, the data in the table (only the records I have scanned, not the entire table) will be exported to a CSV file and used in another machine. This other machine will generate a new CSV file with the original data plus a new field (FinalWeight) which I would need to import back into the database.
I am fairly stumped as to how I might go about this, I have tried using temporary tables, but I seem to be making a mistake somewhere.
Any help would be greatly appreciated.