inputting data

[Anon]

question: do i have to do anything special to my database setup in order to input more than one entry for the same field ? for example, if i want to enter more than one field of study a scholarship is offered to like : Architecture AND Geography can i simply input both or is there something i dont know ???

[Anon]

Storing more than one value for a given field in a record is not good method.

You better put field of study in separate table using the primary key of the first table(the one you are using now) as foreign key of the new table(containing fields of study). Now you can add a number of fields in this table for a give record in the first table. You can set relationship to display results ...

chew

[Anon]

hmm - im not sure how what it is yer sayin. the tables i have created are: scholarship table which contains information pertaining to a scholarship (obviously), then i also have a table for the fields. im not sure i understand how it is yer sayin i could have more than one field for a scholarship though??(im new to dbs-and php both)