Search results

Neileg, I'm so sorry. I haven't signed on in some time. Thank you very much for your help with this. I'm still confused about how the PK is being put into the FK, because it happened BEFORE I constructed any forms, but I'll take the word of the experts and not plan on it. :) Pat -- Thank...

Pat -- I'll give it a try. It's not been working too well so far, but I started over with a new, clean DB, set up the relationships, and built some forms. So far, so good. I really appreciate the help you've been providing.

Thanks, Neil. I guess I just can't figure out how the FK is being populated from the PK to the FK if it's not being propogated by Access. :confused: Thanks for the information, I really appreciate.

Well ... no, it wasn't. I haven't built the form/subform yet, because I keep getting confused about which fields to link. The forms I have are all sort of pop-ups, but I can't figure out how to pass one record from form to form so that the various tables all have the new record updated/created...

Outstanding. Thank you so much for that information. I'll look into the code needed to do this. I find it interesting, however, that the database DOES take the LocID field from the Location field and plug it into the RoomLocID field (FK) of the related table Room. It doesn't go on to add the...

No sir, I'm just trying to get the key field from one table to go into another through cascading update. It works for one, but not for the other. I assumed the explanation was the level of cascading Access will do, though. If this is incorrect, any assistance in getting this to work is...

Thanks! Thanks, guys. I appreciate the help. The new relationships between the tables seem to be facilitating the things I want to do, and I guess I'll just have to deal with the upating of ONE of the fields in another way. I've populated a combobox with the records from a table based on the...

Done! I actually named them DevID, RmID and LocID. I used the full names in the FK fields of the child tables. Done. So, I removed it, but then I added it to the Room table? Did I understand this correctly? The Room table LocationID field is now getting updated by the DB, but the DeviceVC...

I'm working up in Chicago, but live WAAAYYY north of there. Ugh. Okay, but my thinking here was there could be many devices in a given location. I may need to pull the device and it's location information for reporting later on. Is this going to present a problem? :confused: I'm trying...

Hello, everyone! I have an Access 2002 DB. My question involves table relationships and cascading update. Here's the set-up I have: I have three tables in use, and their structure is described below: tblDevicesVC ID (PK, AutoNumber) LocationID RoomID (lots of other fields) tblLocation...