lord_claude
New member
- Local time
- Today, 04:56
- Joined
- Sep 28, 2020
- Messages
- 4
Hi
This is my first post. I could not see another post regarding this and I hope I am posting in the right place
When I enter a record into my DB, I would like Access to create 5 other records that have two different fields of information in, one from a different table (Product_Colour) and one from no table (the "product code") which is externally generated. At the moment I am manually copying the record and changing the relevant fields.
Background
I am creating a multi coloured logo that has to have one of it's colours changed depending on the colour of the background (the black in the logo will need to change to white if the garment is black, otherwise you wont see the black parts of the logo) and the DB need to reflect this as I send the designs to my embroidery machine from Access.
I generate a product code externally in Excel and manually input this, but the suffix letter of this code is a letter denoting the colour e.g. 123456w for white, 123456b for black etc. (I'm sure Access could generate this code, but I will create another thread for that).
So to sum up, when I input my first record I will need Access to create 5 additional records, and to keep all information the same in the additional 5 records except for;
I'm quite new to Access but quite happy just to be pointed in the right direction.
Many thanks
This is my first post. I could not see another post regarding this and I hope I am posting in the right place
When I enter a record into my DB, I would like Access to create 5 other records that have two different fields of information in, one from a different table (Product_Colour) and one from no table (the "product code") which is externally generated. At the moment I am manually copying the record and changing the relevant fields.
Background
I am creating a multi coloured logo that has to have one of it's colours changed depending on the colour of the background (the black in the logo will need to change to white if the garment is black, otherwise you wont see the black parts of the logo) and the DB need to reflect this as I send the designs to my embroidery machine from Access.
I generate a product code externally in Excel and manually input this, but the suffix letter of this code is a letter denoting the colour e.g. 123456w for white, 123456b for black etc. (I'm sure Access could generate this code, but I will create another thread for that).
So to sum up, when I input my first record I will need Access to create 5 additional records, and to keep all information the same in the additional 5 records except for;
- a change to the field Product_Colour taken from the 6 records in the Product_Colour table,
- a change to the last digit in the Product_Code field which I currently manually input (there are only 6 colours and I have a table with the suffixes in). All product codes are the same length
I'm quite new to Access but quite happy just to be pointed in the right direction.
Many thanks