manual data entry in related table field
If my related table B doesn't have the data I need, can I enter it manually into the main table A? I'd like to populate one and the same field EITHER with data from a related table B, OR type it in directly to my main table A. Is this possible? Or do I have to
1/ create a new field I can use for manual data entry in main table A
2/ go back and edit the related table B?