Hello all,
I'm working on developing a minor database. I have 1 table with locations and all set location data in that file. I have several tables with sales data sorted by year and month and so on. I have several queries that sort the data how I want it for easier usage and reporting.
I'm trying to make a form that lists fields from the monthy sales and yearly sales tables, with one field for inputing a "reported sales" that will be manually keyed in on this form and stored into the monthy sales table. In that same form I'm trying to display 2 field from the Locations file for them to referance, and if needed change/update those 2 fields as needed via this form.
I create the form and set it up how I think it should look and flow, but all fields are unable to have data entered. I'm getting frustrated and starting to look at a longer and more complex was around my inability to set the form up correctly. Any help or insite would be great. Thanks for your time.
note: no VB skills here, so I hope this doesn't require any special codeing. I don't think it does, I think I'm just over looking something.
Scott
Access Noobie
I'm working on developing a minor database. I have 1 table with locations and all set location data in that file. I have several tables with sales data sorted by year and month and so on. I have several queries that sort the data how I want it for easier usage and reporting.
I'm trying to make a form that lists fields from the monthy sales and yearly sales tables, with one field for inputing a "reported sales" that will be manually keyed in on this form and stored into the monthy sales table. In that same form I'm trying to display 2 field from the Locations file for them to referance, and if needed change/update those 2 fields as needed via this form.
I create the form and set it up how I think it should look and flow, but all fields are unable to have data entered. I'm getting frustrated and starting to look at a longer and more complex was around my inability to set the form up correctly. Any help or insite would be great. Thanks for your time.
note: no VB skills here, so I hope this doesn't require any special codeing. I don't think it does, I think I'm just over looking something.
Scott
Access Noobie
