Relationships

[mariam_s]

Hi

I had to delete a relationship so i could change the data type of a field, now when ive gone back to put the relationship back, it isnt allowing me to enforce referential integrity like it was before.

The error message im getting is "relationship must be on the same number of fields with the same data types" but they previously weren't

confused !



Also, how do I make the database look "pretty"?

TIA

[Micron]

for Q1, it seems too obvious so I must be missing something. Suppose both fields contained numbers but you had set their data types to text and joined them. Then you changed one to number data type (e.g. long integer) but didn't change the data type of the other end of the join. It stands to reason that you would not be able to re-establish the join, never mind enforce referential integrity. It almost sounds like you're saying you can make the join and save it, but you can't enforce referential integrity. That doesn't make sense to me, but then I've never tried to join 2 fields of dis-similar data types.

As for Q2, that is a highly subjective question. Employ pleasing aesthetic design might be an answer. I wonder if you are overly concerned about eye candy before getting the operation and efficiency worked out...

[davegri]

Also, how do I make the database look "pretty"?

Have a look at http://www.accessforums.net/showthread.php?t=58464
Over 560 downloads and counting.