I am trying to create a many to many relationship. I have found this to be quite hard in the standard system however found a simple work around (or so I think) and wanted to know if it is possible to pass the unique ID from two different tables into one field on a separate table.
For example:
Table 1 = projects
Table 2 = vendors
Table 3 = bidder list
each table has a unique ID. I would like to take the ID of the Project and ID of the Vendor and combine them into the Bidders list table as the unique ID. This will allow the owner of the project to track which vendor has signed up to bid the project as well as allow the vendors to see which project they are signed up to bid.
If ths is not possible how can I creat a many to many relationship with out much custom codeing?
I am a bit new to all of this so any help is GREATLY appreciated.
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
dbaratz
I am trying to create a many to many relationship. I have found this to be quite hard in the standard system however found a simple work around (or so I think) and wanted to know if it is possible to pass the unique ID from two different tables into one field on a separate table.
For example:
Table 1 = projects
Table 2 = vendors
Table 3 = bidder list
each table has a unique ID. I would like to take the ID of the Project and ID of the Vendor and combine them into the Bidders list table as the unique ID. This will allow the owner of the project to track which vendor has signed up to bid the project as well as allow the vendors to see which project they are signed up to bid.
If ths is not possible how can I creat a many to many relationship with out much custom codeing?
I am a bit new to all of this so any help is GREATLY appreciated.
Link to comment
Share on other sites
1 answer 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.