General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>So, I can not use the Database Designer because I "have" to use a Regular Index instead of Primary or Candidate Index? I need the DUPE records in both tables. I was told to NEVER, NEVER, NEVER use Unique Index ;)
You should have a unique id on each table. Makes life a lot easier. Just have a function that generates them by incrementing a value in your "ids" table. See the VFP help for this.
>Oh oh oh, I realize something now, I think I need many-to-many relationship, I see. I have never used that so I dont know how that works. Can sxomeone shed light on many-to-many relationships?
It is easier to think of it as a 1-many in one direction, then as a 1 to many in the other direction (as two separate relations).
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only