Multiple forms

[Guest]

I have 4 forms that need to have sequential numbering. The form is filled out
and a number is assigned. The next form is filled out and another number is
assigned ect. We need to have control of the numbering and no form can have a
duplicate number. How can I control the numbering for the 4 forms. I am new
to this and any help would be appreciated.

 

[Joseph Meehan]

I have 4 forms that need to have sequential numbering. The form is
filled out and a number is assigned. The next form is filled out and
another number is assigned ect. We need to have control of the
numbering and no form can have a duplicate number. How can I control
the numbering for the 4 forms. I am new to this and any help would be
appreciated.

Tell us something about the table structure. How many tables are
involved and what kind of fields. Does each form use all the same fields,
some of the same fields, or none of the same fields?

 

[Guest]

The tables have none of the same fields. They are contract request forms and
I have nothing to relate one to another. I have a name field which I made a
combo box, but the name does not relate to another form. That is my main
problem is that their is no relationship. BTW there are 4 forms from 4
tables. Anything more I could provide let me know.

 

[Joseph Meehan]

The tables have none of the same fields. They are contract request
forms and I have nothing to relate one to another. I have a name
field which I made a combo box, but the name does not relate to
another form. That is my main problem is that their is no
relationship. BTW there are 4 forms from 4 tables. Anything more I
could provide let me know.

I would be tempted to make it one table not four, with a field defining
what form it came from, but that would depend on the real situation and the
data being captured from each form.

As an alternative you should be able to make a fifth table with just the
number and each other table linked to it by the number. Make that number
field indexed unique and then use a DMax + 1 function to create a new number
for each new entry.