Wizard

[Jill]

When i create a wizard for my 2 forms to be related is
there a limit to the number off fields i can select. I
have created two tables "Judging Team" & "Scheme". In the
judging table i have 45 fields however i need Scheme Name
and SCheme ID from the "SCheme table" in here but access
wont allow it. The message that appears simply says "the
wizard was unable to create your form"

Am i doing something wrong and is there another way of
doing this. any help i would be grateful for

Jill Cooper

 

[Evi]

I can't understand from your description what your database is like. Are
you trying to create a form with a subform? If so, you don't have to rely on
the Wizard.

Are you trying to combine 2 tables into 1?

or are you trying to get the correct SchemeID into the Judging Team table?

Evi

 

[Guest]

From what u have said i think i am trying to combine two
tables in to one, is this possible if so how?
thanks for ur response

 

[Evi]

Firstly, could you tell me what your database is about? What are the field
names. Are the two tables linked by a common field?

Secondly, are you sure you want to combine. You can always create a form
that is based on both tables, if they are linked. So for instance, if you
were a shopkeeper with a table of staff and a table of staff sales which is
linked from the Staff table by the StaffID field, it would be a really bad
idea to combine those two tables but you could make a form, report that
shows the data from both tables.

If you are certain this is what you want to do (you got a bit carried away
with your relational tables when designing the database) then you can use an
update query if the tables have a linking field. So if TblScheme is linked
to TblJudgingTeam by ShemeID and you want SchemeName to end up in
TblJudgingTeam then:

Create a field in TblJudgingTeam called SchemeName.
Put ShemeName from TblJudgingTeam into a query. Add TblScheme to the grey
area above the grid using the Add Table button. If the SchemeIDs aren't
automatically joined then join them. You still only have one field in the
query, SchemeName from TblJudgingTeam. It has no data in it.

Change the query to an Update Query using the down arrow by the Query Type
button.

In the Update To line type

TblScheme!SchemeName

Do this with a copy of your database first to check that the results are
what you expected.

BUT if there are a choice of SchemeNames which are repeated throughout the
table then this is a giveaway that your first design was correct. So eg. if
the SchemeName could be one of 5 different names and there are 3 records
with 1 schemeName and 2 with another then this shows that you should stick
with your original design. You can still display the fields from the
JudgingTeam table with the SchemeName using a query.

Evi