... that references an autonumber PK in another table. I'd like to be able to just paste information in from Excel, however in Excel the information is stored as a client name. So, as an example:
My excel spreadsheet looks like this:
Hedge Fund Name Portfolio Name Portfolio Type Value Chase Fund Chase Fixed Income Buyout $1,000,000
and my access data dump form has the following headings:
fundManagerID_FK portfolioName portfolioType portfolioValue
I have a 'fundManager' table that holds only fundManagerID_PK and the fundName.
So: my dilemma is it does not allow me to easily paste my excel data in as it expects the auto-numbered PK. From looking at the properties of a combo box I see that the answer lies somewhere in changing the 'Row Source / Row Source Type' however it appears that text boxes do not have that option.
I apologize in advance if this is a silly question. I am very very new to Access. Thanks!