Create text boxes based on user input

[sunilvedula]

right now i understand abt the table part and th design(though designing the table was never a issue- always tried to follow 3NF) but what still worries me how do i create space in the form for the user to enter the multiple entries? how can i create more boxes on the form if required? i think i am confused. sorry if i am doing the same to you all.

 

[Rich]

Multiple entries will simply become multiple records, as for allowing the user to add their own textboxes my advice is the same as all others posting here, don't even attempt it, you'll be letting yourself take the blame when the db no longer works

Add as many fields as you think will be required, you can of course also create a "Notes" field which will allow users to add additional data that they think may be relevant

 

[gemma-the-husky]

in general, if you think you need to add controls to a form dynamically. this really points to data analaysis problems (ie normalisation)

yes, controls can be added at run-time - but this is complex, and would need advanced programming skills - its much more likely that the database design just needs improving

data analysis is often a stepwise refinement thing - you do it, improve it, do it again etc - the only problem is that sometimes you have to start over and recode parts of your app, when it turns out the design needed changing - this is still better though than trying to make a bad design work.

 

[sunilvedula]

in general, if you think you need to add controls to a form dynamically. this really points to data analaysis problems (ie normalisation)

yes, controls can be added at run-time - but this is complex, and would need advanced programming skills - its much more likely that the database design just needs improving

were you able to have a look at my problem. I think i have no issue with my table structure My db already contains 14tables). it perfectly is fine. after my rethinking & studying a bit and re looking at my entire database i felt the structure is fine. Yes there can be one bit that can be done is the place where i was requesting more fields to be added (where all this came from) i can create another table to store all this data and link them with the original table with a common identifier and unique key (PSK) which would allow me any amount of data to be entered. My second table fields would contain PSK, date, merchant name, amount, pos....
On my main form which is the "main issue", i need to create dynamically text boxes but as suggested not a good option so i need to give an option ,if they want to enter multiple data then to create a sub form which they can enter any numbe of rows of data.

let me know if there is a better alternative or also if my solution is not right else there can be a better alternative

 

[dbDamo]

Your solution is correct

 

[sunilvedula]

Thank you one and all and especially dbDamo for all the inputs. I am now also keeping in mind the Normalization concepts which at no cost should be avoided while designing a database. I hope i have got the solution by creating a subform to enter all records which would go into another table and when required for the output would pull data from the two tables. That resolves all theproblems. thanq all. It has been quite informative and thinking.