This topic is locked
[SOLVED]

 Can I replicate a custom ADD/EDIT Form on a new table

4/24/2012 10:22:33 AM
PHPRunner General questions
author

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:

  1. Table A - has all the fields for the forms
  2. 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:
  3. Create a new table (Duplicate Table A to Table C)
  4. 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!!

P
procheck 4/24/2012

Have you looked at creating a view? This might work for you.

500512 4/24/2012

Thank you...had to modify the form a little but it was online within 10 minutes!!
Again, thank you!!