Tezcatlipoca
Registered User.
- Local time
- Today, 09:53
- Joined
- Mar 13, 2003
- Messages
- 246
Hi all,
I'm currently building a small database for work, which will act as a call log for members of our organisation calling up for help.
I'm pretty fluent in VB and reasonable in Access, but admit that I've never really had call yet to play with relational tables, so would greatly appreciate some advice.
The attached file is the basic backend of my database, to which the front end connects via table links.
There are two tables relevant to my current issue; Members and Logs. What should happen is the following:
A user receives a call from a member, who gives their membership number. Using the main user interface form (already written), the user finds that member in the database (the members table will eventually hold a list of all membership numbers, and the main form has a search box whose control source will be the Members table).
Once they have the record on screen, there are two boxes a tthe bottom of the form. The one on the left allows them to add the details of the call they have received, and is a free text field (say, for example, "Joe Bloggs called to say his order has not arrived"). When finished, they click a Save button to save the call details. The box on the right is a list of all previous calls the member has made. The user is able to select one of these as required, and the details of that call fill out in the box on the left, a little like clicking on an email and having the reading pane fill out. The details that populate this righthand box are the rows from the table Logs.
So, as I understand it, my table Logs should be a child(?) of table Members, with all rows in Logs that have - say - membernumber 123, being related to the one row in Members for member 123.
Can anyone provide any advice as to how I can achieve this, and, if possible, provide an example?
I'm currently building a small database for work, which will act as a call log for members of our organisation calling up for help.
I'm pretty fluent in VB and reasonable in Access, but admit that I've never really had call yet to play with relational tables, so would greatly appreciate some advice.
The attached file is the basic backend of my database, to which the front end connects via table links.
There are two tables relevant to my current issue; Members and Logs. What should happen is the following:
A user receives a call from a member, who gives their membership number. Using the main user interface form (already written), the user finds that member in the database (the members table will eventually hold a list of all membership numbers, and the main form has a search box whose control source will be the Members table).
Once they have the record on screen, there are two boxes a tthe bottom of the form. The one on the left allows them to add the details of the call they have received, and is a free text field (say, for example, "Joe Bloggs called to say his order has not arrived"). When finished, they click a Save button to save the call details. The box on the right is a list of all previous calls the member has made. The user is able to select one of these as required, and the details of that call fill out in the box on the left, a little like clicking on an email and having the reading pane fill out. The details that populate this righthand box are the rows from the table Logs.
So, as I understand it, my table Logs should be a child(?) of table Members, with all rows in Logs that have - say - membernumber 123, being related to the one row in Members for member 123.
Can anyone provide any advice as to how I can achieve this, and, if possible, provide an example?
