Search results

Hi Plog -- I believe I figured it out -- attached a new relationship diagram for your comment...

Hi Plog -- I don't have any sample data in the DB yet -- it would be the same information that was in the spreadsheet...I can't figure out the data flow to understand where to enter the data and how to display it all (because the Trip Details table isn't all the information that needs to be...

Hi Plog -- ok -- I simplified what I'm doing into the table (Trip Details-Copy of)...the fields do not represent all of the data I need to eventually "display" but I hope it lays the foundation for multiple trips... where the user will eventually only enter the information for the table 'Event...

Hi Plog -- appreciate the help but your last comment has me really confused now...I still don't know how to have data from one table populate multiple fields in something else (regardless if it's to a table, form, report...etc)...based on one select. the relationship thing has forever confused...

HI Plog... perhaps I'm using "pass" too liberally...piled with potential other confusion -- here is my train of thought to this point My goal: take the attached workbook and turn it into a Access DB...where trips tab is the FINAL product... My thoughts so far: 1. separate table for location...

Hi Plog -- thanks for the help -- but I don't want to view a certain record from CONUS_Per_Diem, I want to pass those values to a different table. I don't understand how the DoCmd.OpenForm performs the data pass.

Here is the table I'm starting with (which I use a macro to import from a spreadsheet that I receive from a different website) CONUS_Per_Diem ID, autonum, primary key, 39084, 39085, 39993 State, Short Text, State Name, ALABAMA, ALABAMA, ARIZONA Location, Short Text, City within State...

Greetings: thanks for your information -- I'm obviously not describing what I want to do correctly.... OR.... I'm not understanding how to do what you've explained....HELP!! Let's say I have Table "Fees" and I have a form (or report) called "Total" where I want to be able to make ONE...

Greetings: Just a random Access user -- trying to make a couple useful databases...already posted a question...looking forward to talking with you! :)

Greetings: I'm building a database and am trying to figure out this... I have a table with multiple fields that I want to populate into a form,table, etc... just by selecting one item from the source table (lookup or row source). For example, I want the location, hotel cost, and meal cost to...