I have a table with 70+ fields that I need to split into two separate tables with approx 35 fields in each. Using the table Analyzer allows me to only add 15 fields max in a table. Is there a way to split the tables and MAINTAIN all links and lookups in the forms, reports, etc. Thanks for any help.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.