Hi i would like to know if anybody know if i can keep some data in a field in datasheet view & or Form view ?
i whant teh user to select a cathegorie but i dont whant to keep the data in the same table so i setup a "Type" table
plus a parts table & a Item table in PArt i have the Type info for that sepecific item that is how i filter by selecting a type in a field witch is looked up in the type table. Works for filtering but when i change te type the entire type colum changes to the selected type.
I think i have to change the my control source to the type in the hardware & kinda lookup to the selected product no
got any sugestions ?
im kinda lost here !
Tanks to ya all ...
Thewizz
i whant teh user to select a cathegorie but i dont whant to keep the data in the same table so i setup a "Type" table
plus a parts table & a Item table in PArt i have the Type info for that sepecific item that is how i filter by selecting a type in a field witch is looked up in the type table. Works for filtering but when i change te type the entire type colum changes to the selected type.
I think i have to change the my control source to the type in the hardware & kinda lookup to the selected product no
got any sugestions ?
im kinda lost here !
Tanks to ya all ...
Thewizz