The workflow is as follows.
One group lists the equipment required - Table A
Second group needs to take this equipment data and then send it to three or more vendors to get quotations so each record from Table A will generate 3 or more records in Table B. However, this group would not like to enter equipment/rfq field data again from Table A
What is best way to setup? Any thoughts appreciated.