Home › Forums › ACF PRO › Creating a searchable 'database' from excel sheet › Reply To: Creating a searchable 'database' from excel sheet
I suggest you add both restaurant and supplier as custom post types and then use the post object field or the relationship field to create the connection/relationship. With relationship field, you can query them by following this article: https://www.advancedcustomfields.com/resources/querying-relationship-fields/. But I believe you can do it by using the post object field too.
I hope this helps 🙂
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
🚨 The 2023 ACF Annual Survey closes tomorrow! This is your last chance to complete the survey and help guide the evolution of ACF. https://t.co/0cgr9ZFOJ5— Advanced Custom Fields (@wp_acf) May 18, 2023
© 2023 Advanced Custom Fields.