database problem

2015-03-25 Thread Mary Lou Trice
Hi Folks, I have created 2 tables in design view: Basic TableID (key) Integer [INTEGER] Last Name    Text [VARCHAR]..other varchar fields** Dues TableID (Index) not unique    Integer [INTEGER]Dues Paid      Decimal

database problem

2015-03-25 Thread Mary Lou Trice
Hi Folks, I have created 2 tables in design view:  Basic Table  and  Dues Table. Please read the attachment to see the tables.  My previous e-mail was not so easy to read. There is a relationship between Basic.ID and Dues.ID I can enter data into the Basic table but cannot enter data intothe