Hi, I am trying to create a duplicate of a table, form, and report for a secondary use, and I am having trouble getting all of the relationships set up properly.
Right now I have a Table for purchases, and form to enter data into said table, and a report to display a purchase order.
I would like to duplicate all of this info and use the same basic format to create a new table for requests for quotations, which would be separate from the purchase order table.
I can duplicate the table fairly easily and rename it to Request for Quotations, but how do I duplicate the forms and reports and get them to update the Request for Quotations table rather than the original table?
Thanks,