Im a beginner learning vb 6 on my own, Im trying to write a program to figure electric bills. My problem is that one person may have several "map numbers" seperate bills, and I'm needing a way to associate a "map number" ,which contains hyphens, with a persons information , ie: name, address, so on. Then from a list box select the "map number" and display last recorded reading, for the specified number. My main problem is if I need to programmatically add a seperate table for each number, with fields , or if one common table would be enough to handle several different "map numbers" with accompaning fields, ie: amnt of bill, reading, etc.
The bill is figured by using the present meter reading of the current month subtracted from the present reading from the past month. So the records will need to be cross referenced. ( current month, past month)
If anyone could help I would greatly appreciate it , Ive been racking my brain on this for some time now