The Bid Table holds every bid our company has. It includes a BidID number, Project Name, Contractor ID, Date created, etc
The Est Table is currently empty
I want it so every time I enter new data into the Bid Table, it automatically copies the same BidID, Project Name, Date created, etc, over to the Est Table.
I have a triggered action that runs actions on insert data event, INSERT into Est Table with all of the fields I wish to be copied over.
I have the BidID set as an integer for the Est Table.
As it is now, when I create new data in the Bid Table, a new entry is created in the Est Table, but none of the fields are filled out and the BidID is wrong (it just counts one up from the previous entry in Est Table, not the same BidID from the Bid Table).
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
kpcollier
I have two tables, Bid Table and Est Table.
The Bid Table holds every bid our company has. It includes a BidID number, Project Name, Contractor ID, Date created, etc
The Est Table is currently empty
I want it so every time I enter new data into the Bid Table, it automatically copies the same BidID, Project Name, Date created, etc, over to the Est Table.
I have a triggered action that runs actions on insert data event, INSERT into Est Table with all of the fields I wish to be copied over.
I have the BidID set as an integer for the Est Table.
As it is now, when I create new data in the Bid Table, a new entry is created in the Est Table, but none of the fields are filled out and the BidID is wrong (it just counts one up from the previous entry in Est Table, not the same BidID from the Bid Table).
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.