Forms - Sturcture trouble

K

kimgirin

Hi,

I'm trying to create a db with a form where I could input datas to fill
these tables.

T_Fournisseur (company that provide service/product)
FournisseurID
FournisseurName

TLibelle (company that receive service/product; not always given))
LibelleID
LibelleName

TPersref (member of Libelle - not always given)
PersrefID
PersrefName

TType (type of sefvice/product)
TypeID
TypeName

TCompteur (For some providers, like for gaz, water,..., there is comptr
number)
CompteurID
CompteurNumber

TAdresse
AdresseID
AdresseRue
AdresseCodePostal

TInvoice
InvoiceID
InvoiceNumber
InvoiceDate
InvoiceAmount

TComments
CommentsID
CommentsTxt

For the same Adress, I can have different Libellename, invoices and compteurs.
For the same invoice, I can have different typenames, persrefname, comments.
I made linktables for each relation where I joint the key (i.e.
TAdressInvoice, AdressID, InvoiceID)

I have troubles to make a form where I can update all the tables at once. Is
it possible (even with Form and subForm)?
For now it didnt work very well.

Kim
 
Top