adding lines to a form

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

hello,

i am trying to create a inventory for all the tools that
my shop uses. how do i create a form that will
automatically add lines to a form if there is a tool item
in that row.


example

tool name
tool part#
tool description
//with each tool as described above there can be anywhere
from 1 to 100 sub tools.

subtoolname
subpartnum
subpartdescription


//seeing how the number of subtools changes drastically
from tool to tool i was hoping on being able to display
the tools in a form and add the rows that are needed as
needed. also if at all possible would it be possible to
not insert the subtools in a subtable. i hope i made my
self clear. if i did not i will repost


thanks again
 
hello,

i am trying to create a inventory for all the tools that
my shop uses. how do i create a form that will
automatically add lines to a form if there is a tool item
in that row.


example

tool name
tool part#
tool description
//with each tool as described above there can be anywhere
from 1 to 100 sub tools.

subtoolname
subpartnum
subpartdescription
Click to expand...
Don't think about Forms until you have your Tables!

It sounds like you need two tables - a Tools table, and a Subtools
table, in a one-to-many relationship.

With these tables you can base a Form on [Tools], with a Subform based
on [Subtools]. This will let you add an unlimited (well, tens of
millions <g>) number of subtools for each tool, without needing to
change the design of your form at all.
 
Back
Top