Jump to content
  • 0

Passing two parameters to a single field


dbaratz

Question

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

  • 0

How about having a "projID" and "projOwner" in the projects table, and "vendorID" in the vendors table?

Then in the bidders_list table you'd have all 3 fields.

This way a project owner can check his own projects (and who bid on them) and the vendors can check which projects they have bid on.

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...