Hello,
I have been trying to find a way to easily replicate my custom ADD/EDIT form that I have created on a new table.
I have a few forms that I need to build that will have the exact same fields and layout but will have a few changes in the check-box selections only.
Here is my setup for my 1st custom form:
- Table A - has all the fields for the forms
- Table B - has all the check-box selections
I'm using the lookup wizard on the fields using table B information using WHERE "category ='XXXX'".
What I need to do..if it can be done...is use the same custom form as above but, use it when I do the following:
- Create a new table (Duplicate Table A to Table C)
- Create a new table (Duplicate Table B to Table D) but add what I need to add to the categories.
I have tried saving it as a project but that doesn't seem to work or I'm not doing it right. Can this be done? Is there an easier way to do this?
I have searched the forum but have not been successful in finding any information.
Thanks for any hints or tips that you can give me!!