473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Amending detail records

The database I'm developing for a local charity has a table with detail
records of individual transactions with our donors. This table has an
integer "donorID" column that is a foreign key to a "donor" table
containing names, addresses, etc. The data entry people use a custom form
to enter new transactions into the detail table.

Occasionally incorrect data gets entered, so I also want to provide the
data entry folks with a convenient way to amend a detail record.
Specifically, we need the ability to amend *any* field in a record,
including the donorID. And to amend the donorID, the database must
present it to the user in terms of the donor's name and address, not the
user-unfriendly numerical ID itself.

This sounds like such a common requirement in Access database design that
there's a best practice for it. Can anyone help?

Thanks

Rick
Jun 7 '06 #1
1 1943
Use a ComboBox with a RowSource that displays the User Name and Address,
does not display but does store the UserID. The ComboBox wizard will lead
you through creating it. The ComboBox will be bound (have a ControlSource of
the UserID Field in the Transaction Record.

Larry Linson
Microsoft Access MVP
"Rick A" <nn****@optonline.net> wrote in message
news:op**************@amd2.3comc...
The database I'm developing for a local charity has a table with detail
records of individual transactions with our donors. This table has an
integer "donorID" column that is a foreign key to a "donor" table
containing names, addresses, etc. The data entry people use a custom form
to enter new transactions into the detail table.

Occasionally incorrect data gets entered, so I also want to provide the
data entry folks with a convenient way to amend a detail record.
Specifically, we need the ability to amend *any* field in a record,
including the donorID. And to amend the donorID, the database must
present it to the user in terms of the donor's name and address, not the
user-unfriendly numerical ID itself.

This sounds like such a common requirement in Access database design that
there's a best practice for it. Can anyone help?

Thanks

Rick

Jun 10 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: adolph | last post by:
I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru...
1
by: Ozgur YASAR | last post by:
Hi, i need to be able to active; on the first page a process is started with a (master) record insert and it will open next page on the next page a datagrid will be used to insert update...
0
by: Benster | last post by:
Hi there, i'm trying to figure out a way to build a master/detail page set (e.g for news items) with next/previous navigation on the detail page. This sounds easier than it appears to be for my...
15
by: Hexman | last post by:
Hello All, How do I limit the number of detail records selected in a Master-Detail set using SQL? I want to select all master records for a date, but only the first 3 records for the details...
7
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent...
10
by: sara | last post by:
Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines....
1
by: teneesh | last post by:
I have designed a form that should display continuous records in the detail. Everytime a user (including myself) click on the view button to view the detail, it does not display until I stretch the...
1
by: peterkennett | last post by:
OK, I’m new to all this, so forgive me if I missed some easy answer to this problem! I have a report, which is actually going to be a letter. I had no problem adding my return address, salutation...
1
by: Miley | last post by:
Hi everyone, This is my question/problem. I have a table with orders and a table with order details. Clients can order multiple products at once during one order, so one line has to be inserted...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.