Search results

Hi Mike, sorry to bother you again but i'm really struggling with the file you send me. I'm actually completely lost. i have no idea how this junction table works or how it helps me. I don't know if you have the time but do you think it's possible to have a video chat about it? i think it might...

Ok. i'll have a look. i'm just starting a training course at work but i'm impatient to look at your work. i'll keep you posted. again Mike, thank you so much so far!

i've added products in two tables. one for profiles and one for accessories. i haven't linked them yet though

Ok i managed to make the junction table? Do i have to make a new query now? what's the next step to get my subform for my seals to be automaticly updated when i fill in the subform for my profiles?

Ok. i'll give it a try. i'll come back to you with an update. thanks for now!

indeed. some profiles need 2 seals which are different. some have only 1 seal. i have this specification in my products details.

i have different productgroups which i want to add in different subforms. just to give you a bit of background info

sure here it is. but careful, i don't have my product in them yet. i can just try it with 'test products'.

DanielleCO posted the thread Automatic form with calculations based on two tables in Forms.

Hi Mike, yes i did manage. thank you so much. i'm still facing an other problem though. i've added a new post about this. i'll send you the name of my post. maybe you could have a look if you don't mind?

Hi, This the issue i'm facing. I have different products that relate to each other. Example: when i have an order for 6m of a profile, i know i also need to add 6m of a certain seal. i've made a print screen of the how it looks in excel and what i want to achieve. so basicly, when i create a...

no it wasn't. i had a look at a youtube video that i duplicated. it was what i wanted in the video and i made it exactly the same in order to modify it afterwards in fucntion of my needs

Oh! Ok thank you so much. Now i get it :rolleyes:. that's one problem fixed. thank you!

yes that i understand but when i create new products in my table i want to link them to a product category. not in the form but in the table

ok. i'll give that a try. the more i learn about access the less i understand :rolleyes:

sorry Mike60smart but i don't understand. what lookup fields is MajP talking about? those in my tables? for example in my products table i have a lookup to the category. if i set this to text then i can't choose from a list anymore.

ok, i'll give it a try

so what i want to do. i have products with prices, customers and projets. i wan't to create a form in which i can choose my product, add the quantity and then the total price must be shown. then in each form, i want to be able to add the 2 factors that will change my total price. 1 factor will...

Hi, thanks for your reply. if i can't use the lookup then how i get to choose form a list if i want to make sure to always use the same caracteristics?