I'm not sure I fully understand your problem. Isn't it a simple matter of adding a star rating field into your contacts table? Doesn't each contact only have a single star rating, therefore it's a one-to-one relationship?
As for filling in the data, you could just use the replace command, but I assume each contact will have a different rating. If there is a way of determining the rating for each calculation eg sales history, then a calculated replace should do the job.
Thanks for the quick reply. Hey, I know its hard to understand the problem when you can't see everything I can see, so forgive me for not giving you more to go on.
Anyway, I was digging around and found the solution.
I checked the 'Allow creation of records in this table via the relationship' in the Edit Relationship dialog. That's why I used a seperate table for the StarRating.
Thanks for the reply.
Will there be only one rating per contact, either because there's only one user, or because all user's ratings get averaged? Or will each user have their own rating for each contact?
So you're saying that it's a one-to-many relationship i.e. one contact can have many ratings. Is that correct?
Yes, each contact can have a 1 to 5 star rating, and the rating can change over time.
I'm pretty sure I have it solved so not to worry anymore. But I'm happy to discuss further.
It's my first time on this forum, do I need to close the thread?
Sent from my iPhone