Converting form type mid design

J

JackShephard

Hello, I have started with a split form type, and I want to make it a
multi table form without the table view footer.

I am not sure how to convert it, or if I should just copy and paste the
main portion I do want to retain into a new design of the proper form
style.

I have a main table, and a few linked tables that I want to do one to
many of. Most of the main table fields will be present, but not all, and
the one to many will be one main table record to show many records from
another table linked through the main table record ID.
 
J

JackShephard

I'm not following...

Could you provide example data for what you are describing?

You are explaining a "how", but I'm missing the "what".
Click to expand...


I have a main data table with some 15 fields, and a single key field
(DVDs and related info). I have some other tables that have many records
linked to each single key in the main table (Actors, Directors, awards,
etc.).

I began to make a "split form" with the main table. It had the main
table fields on top of a mini view of a per row image of the table in the
footer.

I want to get rid of that split table portion, and convert the form to
a multi-table form so that my single DVD title will be there with all
it's associated info, and a small area will show the director, and
another will show the actors, and another will show any awards given for
the film.

I just wanted to know if I can convert this form, and get rid of the
footer (so far it has no "CUT" highlighted on a right clic) and keep
going, or if it would just be better to create a new form, and start
over.
 
J

JackShephard

I seem to recall a template available from Microsoft that does something
like that. Consider downloading the template and taking a look at how
they've managed that.
Click to expand...


Well, there is no clue as to which one that might be. It certainly
isn't that sad "DVD Database" template they have.

Anyway, I have started over again, and trashed the split form. Thanks
for your help.

I now need to work on nested forms, etc. I now have:

tblMain = Main DVD table with several fields, the main of which are:
DVD_ID
DVD_Title

tblAwards= Award description and key field table:
Award_ID
Award Description

tblRoles = any character, director, or other participant in the film:
Role_ID
Role_Description

tblTitle_Awards = Awards for given titles:
DVD_ID
Award_ID

tblTitle_Roles = Any players in the film:
DVD_ID
Role_ID
Party_ID

tblPeople = Participant names:
Party_ID
Party_Name

I am going to make a sub-form that would list ANY Awards given, and
another sub-form that would list any participants (Roles) that happen to
be included in the data for a given film.

The awards should be easy. The Roles would look up Role IDs and list
Role Names, and then attach Party Names to that through the Party_ID
join. Not as easy... for me anyway.

Sizes of the displayed results vary also, so I have to set aside
"window space", or make second and third page for additional info
perhaps. All linked by DVD_ID, and the other keys that get drawn in by
that hook.
 
J

Jeff Boyce

Jack

As long as you are working with subform like that, consider using a Tab
control on your main form. That way, on one "form", you can put a series of
tabs, each one holding one of your subforms (one subform per tab).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
J

JackShephard

Jack

As long as you are working with subform like that, consider using a Tab
control on your main form. That way, on one "form", you can put a series of
tabs, each one holding one of your subforms (one subform per tab).
Click to expand...


Thanks, I'll likely do just that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query design 0
Access Form Refresh 1
Access Daily Entry with multiple entries per field 0
Separate Form 0
Subforms 8
Continuous subform problem 2
Access Passing data from a form to another form! 0
Form and Table issue - help needed. 1

Top