D
Debbie
Does anyone have any suggestions as to why, when I enter a childID
into my childinfo table it adds the childID (3 times) in 3 different
records.
into my childinfo table it adds the childID (3 times) in 3 different
records.
Does anyone have any suggestions as to why, when I enter a childID
into my childinfo table it adds the childID (3 times) in 3 different
records.
Long Story. The database was made by previous manager. There is aWhy would you WANT to do this?
Creating empty "placeholder" records is essentially *never* either necessary
nor a good idea. What are you trying to accomplish? What tables are involved?
John W. Vinson [MVP]
Why would you WANT to do this?
Creating empty "placeholder" records is essentially *never* either necessary
nor a good idea. What are you trying to accomplish? What tables are involved?
John W. Vinson [MVP]
The childID is the 4 first letters of childs last name and 4 first
letters of childs first name. That is the code we use to look up
records.
Long Story. The database was made by previous manager. There is a
table called Child Acct Table: ChildID: Auto Number
ChildAcctrindebb
ChildInfo Table: ChildAcctrindebb plus many other fields, which
actually have no bearing on what is happening.
When the Auto Number is
typed in to the CHildInfo Table, it creates 3 records. The
relationship is based on the ChildAcct field in the ChildAcct Table
and the ChildAcct in ChildInfo Table.
In the forms, first we go in to a form which is just the Child Acct
Table: this is where we set up the ChildAcct: prindebb. Then we go to
a form called ChildInfo which is the ChildInfo Table. It tells us to
do a search in the ChildAcct field for the child we are looking up
(prindebb). Then we click in the continuous form called Child Info.
The first field in the Child Info Form is asking us to type in the
Auto Number from the Child Acct Table. Once we do that, it creates 3
records.
By what I have explained, can anyone help me figure out what is wrong
with the form setup and why it duplicates the Child Acct into 3
records.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.