open to a certain record in the next form upon button click

  • Thread starter Thread starter reservedbcreater
  • Start date Start date
R

reservedbcreater

either i worded my question wrong or something but i got the wrong answer
last time i asked:

i am browsing though my records on a form with the mouse wheel ok...say i
stop at record #6, and then i click next on the form and it goes to the
next form i want that form to open at record #6(i have an id field and
id#=record#)...........i need this for editing......so i just need it to
open the next form to a certain record when i click next
 
This is, again, a a problem caused by using non-normalised tables.

You're working from a non-normalised (i.e. WRONG) set of data. People here
will not, I think, attempt to explain how to get around that kind of
situation as we get can't handle people trying to kludge their way around
problems. (...and we tend to work on normalised dbs... so it's not a usual
thing for us....)

Your next question to a newsgroup should be... "How do I build a sensible
table structure for this situation?"
 
well then how the heck to i normalize my table structure???

id is on every form its the primary key

the first table/form is general housing information
it has name, and reserve, and phone number and toher feilds...

the next form/table is for the Water Source
it asks what the housing unti's water source is and other questions

Sewage/plumbing

Exterior

ETC.



why wont it work?
 
Back
Top