How can I add fields to an existing database? I have added them in the database management section but they don't appear in the layout or browse mode
they dont just appear. you have to add them to the layout as edit box, drop down list, radio button etc...
Yes and no.
There is an option to automatically "add newly defined fields to current layout" in Edit>Preferences> Layout Tab, but I think most developers quickly learnt to turn that option off as we want control over what goes onto which layout.
Retrieving data ...