i am struggling with a form. it will not output right. The db link is provided

[Mitchell_Collen]

Hi.
All tables are linked with weak entities. However, when i enter data on the
form I can't get it to let me enter more than one partipicant without access
generating a new invoice id. however i need one invoice to many participants.
It wont work and i have no idea what to do at this point. in addition the
workshop will not let me add workshop to invoice. this is a small mdb and i'd
like to email it to anyone who can assist me with the relationships as I
think this is the problem but I don't know what to do. please help me.

I have added this database to a practice website if you can open and look at
my table. I am very new to designing this and the form is just not working.
http://www.tulsamakeupartist.com/about_us.html
the link named: FinalDB5 - INVOICE

-Misty


INVOICE
invoiceNO - autonumber
invoice prices

WORKSHOP
workshopNO - autonumber
workshopName

PARTICIPANT
participantNo
par_Name

This is the processes that are supposed to happen.

user process access process
enter invoice price autogenerate invoice no.
enter desired workshop select list of particpants add
workshop id to invoice
enter participants store first paticipant id to
invoice, store second part. id...

Thanks, Misty

 

[John W. Vinson]

Hi.
All tables are linked with weak entities.

What do you mean by "linked with weak entities"??

However, when i enter data on the
form I can't get it to let me enter more than one partipicant without access
generating a new invoice id. however i need one invoice to many participants.

Sounds like you've based your Form on a multitable query. That's the wrong
approach. Base your Form on the "one" side table in a relationship, and one or
more Subforms on the "many".

It wont work and i have no idea what to do at this point. in addition the
workshop will not let me add workshop to invoice.

If there's no WorkshopNo field in the Invoice table as a foreign key to the
workshop table, then no, you can't.

this is a small mdb and i'd
like to email it to anyone who can assist me with the relationships as I
think this is the problem but I don't know what to do. please help me.

I have added this database to a practice website if you can open and look at
my table. I am very new to designing this and the form is just not working.
http://www.tulsamakeupartist.com/about_us.html
the link named: FinalDB5 - INVOICE

I downloaded it but it is seen as Unrecognized Format - either you're using
2007 (which I'm not, yet) or the database is corrupt.

-Misty


INVOICE
invoiceNO - autonumber
invoice prices

"Prices" plural? Do you have multiple price fields in the table? Do you have
foreign keys (WorkshopNo, ParticipantNo)?

WORKSHOP
workshopNO - autonumber
workshopName

PARTICIPANT
participantNo
par_Name

Split the name into LastName and FirstName fields (at least).

This is the processes that are supposed to happen.

user process access process
enter invoice price autogenerate invoice no.
enter desired workshop select list of particpants add
workshop id to invoice
enter participants store first paticipant id to
invoice, store second part. id...

If one participant can participate in multiple workshops then you need
*another table*, with foreign keys to the Workshops table and to the
Participants table. The participation of a person in a workshop should *not*
be in the Invoice table.

Thanks, Misty

Read up on the principles of database design and normalization; Cheryl's
tutorial and the Database Design 101 links on Jeff's site would be worth a
look.
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]