add fields

[slyfox6915]

Hi i am working on an app that would be used for creating work orders

sometimes we have clients that have 1, 2, 3, 15 equipments for us to maintain

how can i tell access to create the amount of fields needed

i need the following

Manufacturer / model / KVA / S/N / Cabienets / Localasation

like i said some clients may have 2 or up to 25

on a form i would like to have a textbox that asks how many piesces of equipment to service

then it would create to needeed amount of lines to input all the infos


thank you

 

[slyfox6915]

Thank you

working on that now

but i have another question

in my table equipment i have many equipments that is owned by each service locations

i need to do a report for each piece of equipment owned by that client

did i just answer my own question ? been looking at youtube vids all week and not finding what can help

 

[Micron]

Basically the same approach as any form you'd make for this. Main report with client data, subreport with contact data, another sub report for equipment data. Or decide which is most important for a paper form - contact data or equipment. It's all about what you want the report to do for you. Don't worry about sorting/grouping in report queries too much. Reports have their own sort/group features that over-ride whatever you do in the data source (query or table or sql statement).

 

[slyfox6915]

Basically the same approach as any form you'd make for this. Main report with client data, subreport with contact data, another sub report for equipment data. Or decide which is most important for a paper form - contact data or equipment. It's all about what you want the report to do for you. Don't worry about sorting/grouping in report queries too much. Reports have their own sort/group features that over-ride whatever you do in the data source (query or table or sql statement).

I think i figured it out thank you so much

 

[Micron]

Glad to see you figured it out. Thanks for the 'like'.

 

[smozgur]

I think i figured it out thank you so much

@slyfox6915: Please either mark a post that answered the original question or post your own solution and then you can mark it as the solution as it will help future readers.