Recent content by faust9
-
F
two foreign keys in one tbl link to same tbl
Yes, that's what I needed. Thanks a lot. I had a single location table related to both source and destination tables. Thank you so very much for the help.:) -
F
two foreign keys in one tbl link to same tbl
Here's my tables: tblShipping shippingID (primary key, autonumber) sourceLocationID destinationLocationID contactID requestedDate orderedDate transporterID . . . tblLocations locationID (primary key, autonumber) locations What I'm trying to do... -
F
two foreign keys in one tbl link to same tbl
Wow, I've found some good stuff here already... Thanks. PROBLEM: I have a table(we'll call it shipping) that has two columns FK'ed to another table (locations). My problem is I have no idea how to pull the information from the locations table into the shipping table. DESCRIPTION: My shipping...