Re: Use a table with only rdcaccount_id as primary key [message #1800 is a reply to message #1794] |
Fri, 07 November 2008 11:31 |
gpatti
Messages: 283 Registered: August 2008
|
Senior Member |
|
|
Thanks Tony, your reply has given me an idea for a solution that will work in the way I want. I had already taken care of the user not being able to add a second record through validation when the 'New' button was pressed, preventing further processing and giving an error message.
I think the solution I will use is to add a second field as primary key along with rdcaccount_id to comply with the requirements of this functionality. But I will populate it from rdcaccount_id within the code (i.e. an equal value). This means each account can have only one record (they don't need to see the value of the primary key) and I know what the value is (from rdcaccount_id) to be able to retrieve it.
|
|
|