Drop down list values into table

[brlissab]

Hello gurus.
Quite new to acccess, would appreciate some assistance.

So here's what i want acomplish. Have 2 pairs of dependent dropdown lists and i try to put the users choice's on another table.
Here's my tables:

Category
ID > AutoNumber & PK
CategoryName > Txt

Task
ID > AutoNumber & PK
Taskname > Txt
IDCategory > Numerical

M_Machine
Machine > Txt & PK
Type_ID > Numerical

M_Type
Type_ID > Numerical
Type > Txt & PK

and finally the table taht i wanna store information

Data
IDData > AutoNumber & PK
type machine > Txt
machine > txt
IDTask > numerical

The dependent dropdwon lists are perfectlly functionnal on my form (thanks to tek tips FAQ ),but no way, no data in me Data table

By the way how you can "choice" the table to store data from combos and other input fields? Are the current sore data only defined by relationships or you could enter some vba code to accomplish that?
Best regards

 

[TheAceMan1]

How are ya brlissab . . .

I think you should absorb Fundamentals of Relational Database Design, then go back and look at your table schema. This schema determines how hard it will or will not be to complete your design.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[brlissab]

Sure, I wiil check the paper.
So, basically, my problem with the my combo boxes who won't fill data into the table is that i'm wrong with my database design? What would you change?
Thank you for ure advices.
Best regards

 

[TheAceMan1]

brlissab . . .

Perhaps you can upload a scaled down model of your db to [link 4Shared.com]4Shared[/url]. Its free and they'll give you a link to it that you can paste into the [blue]Attachment[/blue] window (just under the main editing window).

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

brlissab . . .

BTW ... postback:
The forms Name & [blue]RecordSource[/blue].
The Name & [blue]RowSource[/blue] of the 4 comboboxes.
The [blue]Version[/blue] access your using.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]