Yep, it was bound to be a mess. No surprise that you had not takers on
cf-talk. The likely reason for the pivot table is that the creators of the
db had no idea what they were doing and they used the pivot table wizard to
make what they thought would work. You need to rebuild from scratch before
migrating. I'd offer to help but I have no time. Good luck with it.
Patrick
>-----Original Message-----
>From: Tony Gruen
>
>
>Jeffrey,
>Thank you for your reply. Your scenario is what I am used to
>experiencing in the past. However, what is confusing me is
>this database
>only has two tables. One named "Exhibitors" and another named "Cats &
>Prods". The Exhibitors table seems to have the list of Category and
>Product integrated into it and I cannot determine the source of the
>relationship. It is not sensitive data so I can share the db
>with you to
>help the explanation.
>
>Tony
Outbound email scanned for viruses. (e232)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
