Database table combination log

[Marcster]

Hi,

I'm trying to set up a simple database (That will grow with more options) that
allow users to select a program from the tblPrograms table and depending on the item selected then chooses
an option in the corresponding table and the newly created record gets stored to tblRequests.

I've filled out tblRequests with samples of what this table should store.
A log of users requests for program/request combination.

But how do I create a table and/or form that allows users to create records like the samples?.

Maybe I need another table?. Relationship?. Other?.

Database setup so far as:

tblRequests
Program
Request
Details
Comments
Date
Name

tblPrograms
Microsoft Word
Microsoft Excel
Microsoft Windows

tblWord
Field Question
VBA Question
General Question

tblExcel
Formula Question
VBA Question
General Question

tblWindows
How to change cursor
How to change desktop background


Thanks,

[CreganTur]

I haven't looked at your database yet, but I don't understand your problem. To me, it seems liek you should just be creating a query with the proper joins to your various tables and then use that as the record source for a data entry form.

[stanl]

I haven't looked at your database yet, but I don't understand your problem. To me, it seems liek you should just be creating a query with the proper joins to your various tables and then use that as the record source for a data entry form.

Agreed. Another way of looking at things is to consider an input or 'queue' table that handles a request then kicks off a stored procedure (you can simulate a stored procedure in Access). The 'queue' gathers all the necessary information from 1 or more forms then distributes the generic queue fields (field1....fieldn where field1 is a PK) into the associated database and calculates a response back to the user filling out the form. Such an architecture permits pretty much unlimited growth and complexity to the db with minimal maintenance. .02 Stan

[orange]

Hi,

I'm trying to set up a simple database (That will grow with more options) that
allow users to select a program from the tblPrograms table and depending on the item selected then chooses
an option in the corresponding table and the newly created record gets stored to tblRequests.

I've filled out tblRequests with samples of what this table should store.
A log of users requests for program/request combination.

But how do I create a table and/or form that allows users to create records like the samples?.

Maybe I need another table?. Relationship?. Other?.

Database setup so far as:

tblRequests
Program
Request
Details
Comments
Date
Name

tblPrograms
Microsoft Word
Microsoft Excel
Microsoft Windows

tblWord
Field Question
VBA Question
General Question

tblExcel
Formula Question
VBA Question
General Question

tblWindows
How to change cursor
How to change desktop background


Thanks,
I did look at your database. And agree with CreganTur that I don't really understand the problem. In my view, again from 30,000 feet, I see your simple database as much like this forum. That is,

requestors -- who pose an initial problem
problems -- issues confronting the requestor (that others may have as well)
responders -- who elaborate on the problem with solutions/comments/ideas
solutions/comments/ideas -- that come from a requestor/responder and
have a date stamp, relate to a specific problem, and that can be categorized in several dimensions, and even tagged with some hierarchical tags

For instance:

John Doe has a problem (Requestor)

"Potential combo boxes/ values on an input form or series of input forms"
Is it SW or HW?
---SW
Is it an Office product? or System SW (Windows...)
YES -- Access (2003)
Is it vba ? or Specific product feature( Excel Import...)
YES --

Description/Comment:
Gets a syntax error when adding a Date value to an SQL string

Possible tags:
SW, vba, Access, SQL, syntax issue

A search and report facility against a few tables, allowing

Date, subject (based on solutions/comments/ideas), tags, requestor/responder....