•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 422,555 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,683 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 6570 | Replies: 15
 |
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation: 
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
well, it doesn't really make any sense to. let's say you add a new part that is going to be used on half of your cars. How is access suppose to know which ones to link to? All of them? the most recent one? none of them?
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
also, if you can give me some specifics about how your database, I might be able to help you figure something out
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by campkev
well, it doesn't really make any sense to. let's say you add a new part that is going to be used on half of your cars. How is access suppose to know which ones to link to? All of them? the most recent one? none of them?
That might be the case most situation but in my case where I have rooms (a room table) and staff (a staff table) then the the composite table/key (staff_rooms table) will show you which staff reside in which rooms and since that the composite key/table (staff_tooms table) is not not populating it does really show that information - so that is why I wanted to know if there was a way of getting this information to be displayed.
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by campkev
also, if you can give me some specifics about how your database, I might be able to help you figure something out
What specifics would you be needing?
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
so a staff person resides in more than one room?
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
Well not just resides but can also have onwership, as a caretaker can have ownership of more than one room as they look after many and in some situation some staff do reside in more than one.
But getting back to the original question - can the we some how get that that staff_rooms table to populate? Where it be use of VBA, form etc?
But getting back to the original question - can the we some how get that that staff_rooms table to populate? Where it be use of VBA, form etc?
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Previous Thread: Frustrated - Please help
- Next Thread: ACCESS Security
