Spwanable Forms?

[clickingwires]

Is there some way that I can make a form that is spawnable?

Example:
User asked a question. How many Dogs? (some number)
Then
Dog (first number)
Info about the dog.

Dog (Second number)
Info

...

Dog (Last Number)
Info

I thought about implementing it with some sort of subform with a loop but I am unsure of how to do this. Can anyone help?

[Scott Price]

Rather than start with thinking about forms, the first thing you should do is design your table structure. Queries come next, then forms, and lastly reports.

This link contains some very helpful information on Database Normalisation and Table Structures

Regards,
Scott

[clickingwires]

I have tables and everything else seems to be working great. But what I want to do is add another table with this information and relate it back to the original.

Rather than start with thinking about forms, the first thing you should do is design your table structure. Queries come next, then forms, and lastly reports.

This link contains some very helpful information on Database Normalisation and Table Structures

Regards,
Scott

[Rabbit]

I'm not sure I follow on what you mean by spawning a form. The phrasing sounds like you're trying to create and open multiple forms but that doesn't seem right.

Rather it sounds more like you're trying to spawn a user defined object much like a game would spawn monsters for a battle.

[Scott Price]

I have tables and everything else seems to be working great. But what I want to do is add another table with this information and relate it back to the original.

Since you already have the tables, let's have a look at their structure.

Here is an example of how to post table MetaData :
Table Name=tblStudent

Field; Type; IndexInfo
      StudentID; AutoNumber; PK
      Family; String; FK
      Name; String
      University; String; FK
      Mark; Numeric
      LastAttendance; Date/Time

Regards,
Scott