I am a newbie and since the days when i first dabbled with Databases and Access was over 10 years ago. A lot has changed or i have forgotten a lot of things. So at work, we thought of using a MS access for job issue tracking and using a sharepoint template. Looks good as everyone can access it.
Only issue is that i have imported a customer spreadsheet (table) with all our current customers on it but i just cannot link it. See the attached. Now majority of querys and macros i have read online dont work with sharepoint, not sure why it is limited.
Can someone please help in telling me what i need to do so the on the Issue Form - the user can type in the name of the customer and instead of the new list being fetched, it fetches our current customer list.
Either way, copy the table from to the another, or changing the list it fetches i just cannot work it out. PLease helppp. Thanks
Below is our relationship, new list and imported list
Thanks in advance, i spent 2 days trying to figure it out, not sure if MS restrict this change or if its my inability.